IF EXISTS (SELECT * FROM sys.objects WHERE type = 'P' AND name = 'sp_UserRole_Delete_ByUserID')
	DROP PROCEDURE dbo.sp_UserRole_Delete_ByUserID
GO
CREATE PROCEDURE dbo.sp_UserRole_Delete_ByUserID
	@UserID INT
AS
BEGIN
	SET NOCOUNT OFF

	DECLARE @_UserID INT 
	SET @_UserID = @UserID

	DELETE FROM dbo.UserRoles WHERE UserID = @_UserID

	SELECT TOP 1 * FROM dbo.UserRoles WHERE 1 = 2
END
GO